package com.ruoyi.trainingManagement.domain.Vo;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.NumberFormat;
import lombok.Data;

import java.math.BigDecimal;

/**
 * 学生成绩Excel导出VO
 */
@Data
public class StudentScoreExcelVO {

    @ExcelProperty(value = "学号", index = 0)
    private String studentNo;

    @ExcelProperty(value = "学生姓名", index = 1)
    private String studentName;

    @ExcelProperty(value = "平时成绩", index = 2)
    @NumberFormat("0.00") // 保留两位小数
    private BigDecimal regularScore;

    @ExcelProperty(value = "期末成绩", index = 3)
    @NumberFormat("0.00")
    private BigDecimal finalScore;

    @ExcelProperty(value = "总成绩", index = 4)
    @NumberFormat("0.00")
    private BigDecimal totalScore;

    @ExcelProperty(value = "绩点", index = 5)
    @NumberFormat("0.00")
    private BigDecimal gradePoint;

    @ExcelProperty(value = "状态", index = 6)
    private String status;
}
